CREATE NONCLUSTERED INDEX [_dta_index_Risk_8_1038626743__K3] ON [dbo].[Risk] 
(
	[Title] ASC
)WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
go

CREATE STATISTICS [_dta_stat_1038626743_1_3] ON [dbo].[Risk]([RiskID], [Title])
go

CREATE STATISTICS [_dta_stat_1038626743_7_1_3] ON [dbo].[Risk]([CreatedBy], [RiskID], [Title])
go

CREATE STATISTICS [_dta_stat_1038626743_7_30_1] ON [dbo].[Risk]([CreatedBy], [Updatedby], [RiskID])
go

CREATE STATISTICS [_dta_stat_1038626743_1_5_12_14_10_19_21_23_30_8_29] ON [dbo].[Risk]([RiskID], [RiskStatus], [CurrentRiskFreq], [CurrentControlEffect], [CurrentRiskImpact], [TargetRiskImpact], [TargetRiskFreq], [TargetControlEffect], [Updatedby], [RiskManagerID], [PIIID])
go

CREATE STATISTICS [_dta_stat_1038626743_5_12_14_10_19_21_23_30_8_29_28_1] ON [dbo].[Risk]([RiskStatus], [CurrentRiskFreq], [CurrentControlEffect], [CurrentRiskImpact], [TargetRiskImpact], [TargetRiskFreq], [TargetControlEffect], [Updatedby], [RiskManagerID], [PIIID], [DataClassificationID], [RiskID])
go

CREATE NONCLUSTERED INDEX [_dta_index_Person_8_388196433__K5] ON [dbo].[Person] 
(
	[EMailName] ASC
)WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
go

CREATE STATISTICS [_dta_stat_388196433_1_2] ON [dbo].[Person]([PersonID], [PersonnelNumber])
go

CREATE STATISTICS [_dta_stat_388196433_9_1_5] ON [dbo].[Person]([FullName], [PersonID], [EMailName])
go

CREATE STATISTICS [_dta_stat_388196433_2_1_9_5] ON [dbo].[Person]([PersonnelNumber], [PersonID], [FullName], [EMailName])
go

CREATE NONCLUSTERED INDEX [_dta_index_Task_8_1058102810__K10_K5_4] ON [dbo].[Task] 
(
	[StatusID] ASC,
	[GroupID] ASC
)
INCLUDE ( [CategoryID]) WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
go

CREATE STATISTICS [_dta_stat_1058102810_4_10] ON [dbo].[Task]([CategoryID], [StatusID])
go

CREATE STATISTICS [_dta_stat_1058102810_6_10] ON [dbo].[Task]([AssignedToID], [StatusID])
go

CREATE STATISTICS [_dta_stat_1058102810_5_10] ON [dbo].[Task]([GroupID], [StatusID])
go

CREATE STATISTICS [_dta_stat_1058102810_10_1_6_5] ON [dbo].[Task]([StatusID], [TaskID], [AssignedToID], [GroupID])
go

CREATE STATISTICS [_dta_stat_1058102810_1_6_5_4_10] ON [dbo].[Task]([TaskID], [AssignedToID], [GroupID], [CategoryID], [StatusID])
go

CREATE NONCLUSTERED INDEX [_dta_index_History_8_91147370__K3_K4D_K7] ON [dbo].[History] 
(
	[RiskID] ASC,
	[CreatedDate] DESC,
	[PersonID] ASC
)WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
go

CREATE STATISTICS [_dta_stat_91147370_4_7] ON [dbo].[History]([CreatedDate], [PersonID])
go

CREATE STATISTICS [_dta_stat_91147370_2_4] ON [dbo].[History]([FieldName], [CreatedDate])
go

CREATE STATISTICS [_dta_stat_91147370_2_3] ON [dbo].[History]([FieldName], [RiskID])
go

CREATE STATISTICS [_dta_stat_91147370_7_3_4] ON [dbo].[History]([PersonID], [RiskID], [CreatedDate])
go

CREATE STATISTICS [_dta_stat_91147370_3_4_2] ON [dbo].[History]([RiskID], [CreatedDate], [FieldName])
go

CREATE STATISTICS [_dta_stat_91147370_1_3_4_2] ON [dbo].[History]([HistoryID], [RiskID], [CreatedDate], [FieldName])
go

CREATE NONCLUSTERED INDEX [_dta_index_AuthZUserRoleMapping_8_1872725724__K2_K3] ON [dbo].[AuthZUserRoleMapping] 
(
	[AuthZUserID] ASC,
	[RoleID] ASC
)WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
go

CREATE STATISTICS [_dta_stat_1872725724_3_2] ON [dbo].[AuthZUserRoleMapping]([RoleID], [AuthZUserID])
go

CREATE NONCLUSTERED INDEX [_dta_index_OrganizationHierarchy_8_1746105261__K2_4_5] ON [dbo].[OrganizationHierarchy] 
(
	[OrganizationHierarchyCode] ASC
)
INCLUDE ( [ParentOrganizationHierarchyCode],
[ParentOrganizationHierarchyID]) WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
go

CREATE STATISTICS [_dta_stat_1746105261_7_2] ON [dbo].[OrganizationHierarchy]([Active], [OrganizationHierarchyCode])
go

CREATE STATISTICS [_dta_stat_1746105261_6_7] ON [dbo].[OrganizationHierarchy]([OrganizationHierarchyLevel], [Active])
go

CREATE NONCLUSTERED INDEX [_dta_index_AuthZUser_8_1904725838__K4_K1_K2_3] ON [dbo].[AuthZUser] 
(
	[sAMAccountName] ASC,
	[AuthZUserID] ASC,
	[PersonnelNumber] ASC
)
INCLUDE ( [DisplayName]) WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
go

CREATE STATISTICS [_dta_stat_1904725838_3_4_1] ON [dbo].[AuthZUser]([DisplayName], [sAMAccountName], [AuthZUserID])
go

CREATE STATISTICS [_dta_stat_1904725838_4_2_1] ON [dbo].[AuthZUser]([sAMAccountName], [PersonnelNumber], [AuthZUserID])
go

CREATE STATISTICS [_dta_stat_1904725838_2_1_3_4] ON [dbo].[AuthZUser]([PersonnelNumber], [AuthZUserID], [DisplayName], [sAMAccountName])
go

CREATE STATISTICS [_dta_stat_320720195_3_2] ON [dbo].[RiskGroupMapping]([RiskGroupID], [RiskID])
go

CREATE STATISTICS [_dta_stat_2014630220_3_2] ON [dbo].[RiskOERMClassificationMapping]([OERMClassificationID], [RiskID])
go

CREATE STATISTICS [_dta_stat_1076198884_6_3] ON [dbo].[Geography]([Active], [Region])
go

CREATE STATISTICS [_dta_stat_1710629137_3_2] ON [dbo].[RiskRegionMapping]([GeographyID], [RiskID])
go

CREATE STATISTICS [_dta_stat_1710629137_1_2] ON [dbo].[RiskRegionMapping]([RiskRegionMappingID], [RiskID])
go

CREATE STATISTICS [_dta_stat_1794105432_3_2] ON [dbo].[RiskOrganizationMapping]([OrganizationHierarchyID], [RiskID])
go

CREATE NONCLUSTERED INDEX [_dta_index_Person_8_388196433__K2_K1_K9_K5] ON [dbo].[Person] 
(
	[PersonnelNumber] ASC,
	[PersonID] ASC,
	[FullName] ASC,
	[EMailName] ASC
)WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
go